Re: duplicate key

Поиск
Список
Период
Сортировка
От pascal bérest
Тема Re: duplicate key
Дата
Msg-id a05200f14ba489f0cde0e@[80.236.54.8]
обсуждение исходный текст
Ответ на duplicate key  (pascal bérest <lists@magnetophone.com>)
Список pgsql-general
>pascal =?iso-8859-1?Q?b=E9rest?=  <lists@magnetophone.com> writes:
>  >> Also, it would be useful to see the ctid, xmin, xmax, cmin,
>  >> and cmax values for some of the sets of duplicate rows.
>
>>  Could you explain where we can have these informations ?
>
>Select 'em.  They're system columns, like OID.
>
>>  We also delete the duplicate keys, but we still have some of them.
>  > We delete again and again, and we still have some of them. Finally,
>  > we delete them manually, and it was possible to REINDEX the table.
>
>So in other words, the evidence is now all gone?  Oh well.

Yes, it's deleted. But we still have them on our production server.
We can restore it on our preproduction server, from a tar of the base.
Could you explain exactle where we can find tthe ctid, cmin, xmin,
xmax values ?
We will redo the test tomorrow.


Thanx very much.


Pascal.

В списке pgsql-general по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: PostgreSQL on Windows [Viruschecked]
Следующее
От: Wenzhe Zhou
Дата:
Сообщение: Re: duplicate key